﻿use housing 
declare @noid varchar(30)
set @noid='20091282'
SELECT * FROM [housing].[dbo].[Apply] where   apply_noid=@noid
--delete from [Apply] where apply_noid='20090147'
SELECT *  FROM [housing].[dbo].[Applicant] where app_noid=@noid
--SELECT * from [Applicant] where app_noid='20090004'

SELECT  * FROM [housing].[dbo].[SubsidyRecord]   where adj_noid=@noid
SELECT  *  FROM [housing].[dbo].[ReduceRecord]  where adj_noid=@noid
SELECT *  FROM [housing].[dbo].[KindRecord] where adj_noid=@noid
SELECT *  FROM [housing].[dbo].[Housing] where hou_noid=@noid
 
  